Custom Queries

In the Input stage of processes that connect to outside data sources, you can create custom SQL queries. To do this, you will need to be familiar with the appropriate SQL syntax and the parameter naming conventions for your data source.

To create a custom query

1. From the Input stage of Field Lookup or Field Verification, select Edit Query....
2. The Custom Query Editor dialog box will open.
3. Under Custom Query, specify a custom query.
4. Under Parameter Names, specify parameter names if applicable (see below). Under Parameter Values, specify corresponding values—you can use the token button to insert any token available to you.
5. Optional: Click Add Parameter to specify additional parameter names and values.
6. When you are finished, click OK.

How to specify the parameter names depends on how you are connecting to the data source:

• When using an ODBC connection, you cannot use named parameters. Use "?" for each parameter name. They will be interpreted in the order in which they are listed.See Screenshot
• With any other type of connection, use the naming convention specific to that connection. Named parameters can be used more than once in the query without being listed more than once in the parameter list.See Screenshot

Note: Tokens generated by custom queries will not be automatically available in the Results stage. You can use them by specifying them in the format %(Column.Column Name) for Real-Time Lookup and %(Lookup Process Name_Column Name) for Lookup, replacing the text in italics with your own information. The column name may or may not be case sensitive, depending on your data source.